NoSQL systems are suitable solutions for big data projects and offer a high level of flexibility in design. A good and efficient schema design for NoSQL wide column stores is not only based on the application’s conceptual data model but also on the queries defined in an application’s workload. In these databases, a manual schema design relies on rules of thumb to choose a good schema. Utility these rules without practices is a big challenge in this area. Because these rules are vague and generic, and must be adapted to each application. One of the ways that researchers use to overcome this challenge is presenting automated schema design. The main contribution of this paper is automated schema design for NoSQL wide column stores. This research proposes a workload-driven approach for the mapping from the application conceptual data model to a database schema with a goal of optimizing query performance. This approach uses workload information to achieve a good workload performance, which result in an optimized schema by minimizing the number of requests to the wide column stores. The experimental results show that automated schema generated by the proposed approach leads to a good workload performance.

In this paper, seismic behavior of wide beams was investigated. First, code provisions and results of previous tests on reinforcement concrete wide beam-column connections were reviewed. After precise investigation of previous test results and in order to detailed study of behavior of wide joints, 4 specimens of exterior wide beam-column connections in scale of 3: 5 were casted and tested under constant axial and cyclic lateral lateral loads. The specimens were designed and detailed in accordance with ACI 318-14 and ACI 352R-02. In tested specimens, differet geometries for columns (square, rectangular or circular) and spandre beams (wide or conventional) were considered. During the tsets, formation of full-width flexural plastic hinge of wide beams was observed in all the specimens without any shear or torsional failure. Energy absorption of specimens was relatively high and that is because of using stirrups at the joint area and axial loads apllied to columns. The width of spandrel beam and geometry of columns influenced the seismic performance of tested specimens. A comparison between experimental results and ACI provisions showed that dimentional limitations of ACI 318 on wide beams can be violated. Also, in wide joints with axial load ratio greater than 15%, the bond performance of column longitudinal bars is improved and ACI 352R provisions in this context can be relaxed.

Background and aim: According to the frequent tooth loss at molar sites and necessity to replace them, the purpose of this study was to evaluate the short term clinical and radiographic outcomes of fresh molar sockets immediately implanted, with tapered wide platform implants.Materials and Methods: 10 patients with the mean age of 46 were treated with the immediate implantation of 12 wide diameter and wide platform implants in the molar sites.Following the atraumatic extraction of molars and preservation of the interradicular septum, implantswere placed. Immediately after the insertion of healing abutment, implant primary stability was tested with the Periotest and the crestal bone level was estimated with the periapical long-cone radiographs.Four months later patients were recalled for final evaluations, the crestal bone loss was measured and the periotest values were judged with the Wilcoxon test.Results: All 12 implants were reported with no pain, infection and continuous radiographic lucency.The average PTV1 and PTV2 reported were -4.9±0.99 and -4.6±1.37 (-2 to -7).The difference between PTVs wasn' t statistically significant (P>0.05).The average crestal bone loss was 0.54±0.96.Conclusion: Successful results were achieved with wide diameter and wide platform implants with the appropriate case selection and surgical technique.

Today, due to massive amount of information, NoSQL databases are used to compute complex data. These databases are used to store semi-structured and unstructured data for big data management. In this paper, fuzzy queries are executed by users on the information stored in the Neo4j graph database, which show results in defuzzy manner. To evaluate the efficiency of the proposed method, we considered a database of manufacturing company. Price and quality fuzzy variables were considered and used to define and execute the fuzzy queries. The results can verify the performance of the proposed method. Additionally, a counselor (who has information about the data) defines fuzzy terms, membership functions, and fuzzy rules table. The most important process in this method is to find the center of gravity in order to defuzzify the final result. So, an algorithm has been implemented for this purpose by C # programming language. The greatest query time is due to find center of gravity. The evaluation results show that the increase in query time by using the proposed approach in comparison to query time by using Cypher language is acceptable due to the complexity of fuzzy concepts. Therefore, the proposed solution will be suitable for using ambiguous and fuzzy queries in large databases.

Database management systems are the main part of information system that the size and complexity of these systems significantly have been increased in recent years. With the growing and being more complicated database management systems, database Administrators face more problems and challenges, so management of these systems is Time-consuming and costly. More over the main part of the total cost of ownership includes the cost of expert database administrator (DBA) who can manage these large and complicated systems. Autonomic databases by providing self-management functionality are caused to reduce the total cost of ownership for a database system. The self-management decisions as the automated schema database tuning depend on the database workload. One of the important issues in realizing the database automated tuning is workload monitoring and analysis for changes detection and schema re-tuning with this changes. In this paper is presented the feedback control loop for continuous monitoring and light-weight analysis of workload in NoSQL column-oriented database. This loop describes a design pattern for self-tuning feature and uses for workload change detection which require automated schema database re-tuning. The experimental results exhibit the effectiveness of the proposed solution for workload change detection.

Fire is one of the hazards necessary to study its effects on various structures. In addition, cities with a pressurized natural gas distribution network or air force distribution network are more prone to post-earthquake fires. Post-earthquake fires involve a large number of simultaneous fires that occur as a result of earthquakes and can cause widespread social and economic damage. This phenomenon may cause more damage to the structure compared to earthquakes. In addition, knowing the extent of heat damage to concrete can help designers in the field of structural reinforcement. Joints are one of the most sensitive areas in all structural frames, including steel and concrete, which are affected by high forces during earthquakes and their performance has a very important effect on the response of the structure. For this purpose, it is important to study the behavior of different types of beam and column joints in different environmental conditions. Extensive studies have been performed on the behavior of steel joints at high temperatures. Also, the behavior of concrete under the influence of thermal stresses has been studied. However, laboratory and numerical data on the behavior of reinforced concrete beam and column joints at high temperatures are not available. In addition, due to the special feature of beam and column joints, ie the passage of part of the longitudinal reinforcement of the beam outside the connection core, in this study the behavior of concrete beam column beams under the influence of thermal stresses is investigated. Beam-column joints in reinforced concrete structures are critical areas that must be prevented from being destroyed. Because damage to these areas can lead to the collapse of the entire structure. Therefore, it is necessary to study the behavior of this part of the structures. In the past, researchers have studied the effect of different parameters on the behavior of reinforced concrete beam-column joints in experiments and numerically. Due to the percentage of wide-beam reinforcements passing through the connection core at the beam-column joints, these areas must be carefully designed to be able to dissipate energy during a fire event. In this study, considering the importance of joints and the different behavior of wide-column joints in reinforced concrete structures, the effect of thermal stresses on these structural components is investigated to determine the effect of different temperatures on the behavior of these joints in relation to the percentage of longitudinal reinforcement. Identify the wide beams that have passed through the outside of the column core. In this dissertation, 9 numerical models of connecting beams and wide columns under fire are investigated. In each of these samples, specific characteristics such as (height of wide beam, surface of beam rebars, strength of concrete and percentage of passers through concrete core) have been investigated. In this dissertation, it was found that with increasing the height of the beam, the fire resistance of the structure increases. Also, with increasing the level of rebar, the strength of the structure increases. As the strength of concrete increases, the structure becomes stronger. Also, by reducing the rebar passing through the concrete core, the strength of the structure is reduced. There is a common feature in all of these issues, and this feature is that all joints begin to form plastic joints at a temperature of about 450 degrees Celsius, and this temperature occurs about 200 minutes after the fire starts in the joints.

Due to the global competition increasing and integration of international markets, customers’ retention is a big challenge for companies in the 21st century and so, study of customers’ loyalty is a vital matter. Therefore, present paper identifies the perspectives of Refah and Shahrvand chain stores’ customers about the quality of services, trust and customers satisfaction to establish their loyalty. Statistical population of this study is all Customers of selected Refah and Shahrvand stores which randomly selected 385 customers and the questionnaire was distributed among them. Results indicate that, from the Customers’ viewpoint, the quality of services (and its five dimensions: tangible services, reliability services, services assurance, personnel accountability in delivering services, personnel empathy in providing services) and also, their trust (confidence) and satisfaction from their stores are desirable and there are no significantly differences between dimensions of stores. As well as, these dimensions have different ranks in the loyalty creation.

While the putting a place of business out to lease is a subject matter which is common in trade and the goodwill, it is a familiar for the both lawyers and merchants. Those matters are not so common and known in respect of e-stores. In this article the attempt is done to light up these subjects, present a legal analysis thereof and to show they are a separate matter of other similar subjects in IT Law like the cyber-squatting. In recent matter, the other's trade mark is used in domain name without his consent that could be settled through ICANN's regulations.